class TaskSqlMap(object):
    login = "select user_id,role_value from aoa_user inner join aoa_role_ on aoa_user.role_id=aoa_role_.role_id where (user_name='{name}' or pinyin='{name}' or user_tel='{name}') and password='{password}'"
    login_log = "insert into aoa_user_login_record(browser,ip_addr,login_time,session_id,user_id) values('{browser}','{ip_addr}',{login_time},'{session_id}',{user_id})"
    update_last_ip = "update aoa_user set last_login_ip='{ip_addr}',last_login_time={login_time} where user_id={user_id}"